﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Maticsoft.DBUtility;
using System.Data.OracleClient;

namespace Xiaov.SmartWeb.Application.TZ.WP
{
  public partial class WPTZData : System.Web.UI.Page
  {
    protected void Page_Load(object sender, EventArgs e)
    {
      string sql = "select * from tz_wpzjsjtz where rq>=:0 and rq<=:1 and jingdui=:2";
      OracleParameter[] paras = new OracleParameter[]{
					new OracleParameter(":0", OracleType.VarChar,30),
					new OracleParameter(":1", OracleType.VarChar,30),
					new OracleParameter(":2", OracleType.VarChar,30)};
      paras[0].Value = Request.QueryString["rq1"].ToString();
      paras[1].Value = Request.QueryString["rq2"].ToString();
      paras[2].Value = Request.QueryString["jd"].ToString();
      DataSet ds = DbHelperOra.Query(sql, paras);
      ds.WriteXml(Response.Output);
      Response.ContentType = "text/plain";
      Response.End();

    }
  }
}